Data management/Exploration & description

We can then save the spreadsheet as a table in Word and modify it further using the Word software to produce the table as shown again below.

Simple descriptive tables can easily be produced in this way for the final report without having to type the contents again from scratch.


Herd group

Number of 
cows   

Mean lactation 
yield

S.E.

KANYAN

83

444

16
KASHON

62

373

 9
KIKAAS

43

275

15
MASHA

11

343

32
MUTONT

48

275

12
RUHENG

35

248

14
RUSHER

22

312

16
RYERU

83

363

10

The table shows that mean milk offtakes varied almost two-fold across the eight regions from a mean of 248 kg in Ruheng to a mean of 444 kg in Kanyan. Thus, to rank cows based on their lactation offtakes we need to take into account the herd group (and also the herd) to which they belong.

We shall now undertake analyses of variance on TOYLD and YLD210 to adjust for herd effects.